{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib as mpl\n",
    "import matplotlib.pyplot as plt\n",
    "mpl.rcParams[\"font.family\"] = \"SeiHei\"\n",
    "mpl.rcParams[\"axes.unicode_minus\"] = False"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>50</td>\n",
       "      <td>【二0三樱花园散客票】</td>\n",
       "      <td>27.00</td>\n",
       "      <td>龙王塘樱花园</td>\n",
       "      <td>119018916</td>\n",
       "      <td>3.213511e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>51</td>\n",
       "      <td>【龙王塘樱花园节假日团队票】</td>\n",
       "      <td>17.00</td>\n",
       "      <td>最新推荐</td>\n",
       "      <td>2016356</td>\n",
       "      <td>3.427805e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>53</td>\n",
       "      <td>【龙王塘樱花园平日团队票】</td>\n",
       "      <td>13.00</td>\n",
       "      <td>龙王塘樱花园</td>\n",
       "      <td>1435016</td>\n",
       "      <td>1.865521e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>62</td>\n",
       "      <td>【龙王塘樱花园散客平日电子票】需提前两小时订票</td>\n",
       "      <td>18.80</td>\n",
       "      <td>龙王塘樱花园</td>\n",
       "      <td>127098</td>\n",
       "      <td>2.389442e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>98</td>\n",
       "      <td>【二0三樱花园团队票】</td>\n",
       "      <td>21.00</td>\n",
       "      <td>龙王塘樱花园</td>\n",
       "      <td>40288</td>\n",
       "      <td>8.460480e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>96</td>\n",
       "      <td>【龙王塘樱花园散客平日周末通用电子票】需提前两小时订票</td>\n",
       "      <td>18.88</td>\n",
       "      <td>龙王塘樱花园</td>\n",
       "      <td>40568</td>\n",
       "      <td>7.659238e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>54</td>\n",
       "      <td>【龙王塘樱花园夜场票】需提前两小时订票</td>\n",
       "      <td>9.90</td>\n",
       "      <td>龙王塘樱花园</td>\n",
       "      <td>45435</td>\n",
       "      <td>4.498065e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>61</td>\n",
       "      <td>大地艺术节+疯狂动物节+203樱花园 大套票</td>\n",
       "      <td>21.00</td>\n",
       "      <td>二0三樱花园</td>\n",
       "      <td>9801</td>\n",
       "      <td>2.058210e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>91</td>\n",
       "      <td>平日 大地艺术节+疯狂动物节+龙王塘樱花园 大套票</td>\n",
       "      <td>13.01</td>\n",
       "      <td>龙王塘樱花园</td>\n",
       "      <td>10625</td>\n",
       "      <td>1.382312e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>92</td>\n",
       "      <td>龙王塘直通车—与樱共舞，来醉美大连，赏浪漫樱花。平日周末通用。需提前两小时订票</td>\n",
       "      <td>38.80</td>\n",
       "      <td>龙王塘樱花园</td>\n",
       "      <td>1704</td>\n",
       "      <td>6.611520e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>49</td>\n",
       "      <td>龙王塘樱花园团队票</td>\n",
       "      <td>200.00</td>\n",
       "      <td>龙王塘樱花园</td>\n",
       "      <td>272</td>\n",
       "      <td>5.440000e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>89</td>\n",
       "      <td>【服务费15元】</td>\n",
       "      <td>15.00</td>\n",
       "      <td>龙王塘樱花园</td>\n",
       "      <td>3000</td>\n",
       "      <td>4.500000e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>101</td>\n",
       "      <td>【二0三樱花园团体票】企事业单位团体票，10人一份</td>\n",
       "      <td>249.00</td>\n",
       "      <td>二0三樱花园</td>\n",
       "      <td>98</td>\n",
       "      <td>2.440200e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>99</td>\n",
       "      <td>龙王塘樱花园学生票/老人票，持学生证/老年证无需换票，直接入园，需提前两小时订票</td>\n",
       "      <td>10.00</td>\n",
       "      <td>龙王塘樱花园</td>\n",
       "      <td>2164</td>\n",
       "      <td>2.164000e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>56</td>\n",
       "      <td>槐花饼，又是一年槐花香，童年的味道</td>\n",
       "      <td>38.00</td>\n",
       "      <td>伴手大连</td>\n",
       "      <td>322</td>\n",
       "      <td>1.223600e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>76</td>\n",
       "      <td>樱桃饼，青春和美好的无限挂念</td>\n",
       "      <td>38.00</td>\n",
       "      <td>伴手大连</td>\n",
       "      <td>315</td>\n",
       "      <td>1.197000e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>72</td>\n",
       "      <td>樱花饼，樱花树下，白头偕老</td>\n",
       "      <td>38.00</td>\n",
       "      <td>伴手大连</td>\n",
       "      <td>300</td>\n",
       "      <td>1.140000e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>58</td>\n",
       "      <td>樱花贺卡，凝固时间，传情达义</td>\n",
       "      <td>29.90</td>\n",
       "      <td>周边小礼</td>\n",
       "      <td>336</td>\n",
       "      <td>1.004640e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>57</td>\n",
       "      <td>樱花风铃，樱花浪漫，许个愿吧，叮当叮当，就要实现</td>\n",
       "      <td>19.90</td>\n",
       "      <td>周边小礼</td>\n",
       "      <td>450</td>\n",
       "      <td>8.955000e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>100</td>\n",
       "      <td>【二0三樱花园散客原价票】</td>\n",
       "      <td>30.00</td>\n",
       "      <td>二0三樱花园</td>\n",
       "      <td>250</td>\n",
       "      <td>7.500000e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>97</td>\n",
       "      <td>节假日  大地艺术节+疯狂动物节+龙王塘樱花园 大套票</td>\n",
       "      <td>17.01</td>\n",
       "      <td>龙王塘樱花园</td>\n",
       "      <td>432</td>\n",
       "      <td>7.348320e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>74</td>\n",
       "      <td>蓝莓饼，遇见莓好，吃到最美的那一颗</td>\n",
       "      <td>38.00</td>\n",
       "      <td>伴手大连</td>\n",
       "      <td>170</td>\n",
       "      <td>6.460000e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>15</td>\n",
       "      <td>5.5寸安卓智能pda景区验券核销小票打印二维码扫描终端可二次开发</td>\n",
       "      <td>1299.00</td>\n",
       "      <td>最新推荐</td>\n",
       "      <td>4</td>\n",
       "      <td>5.196000e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>63</td>\n",
       "      <td>话剧《开心晚宴》—大连站</td>\n",
       "      <td>180.00</td>\n",
       "      <td>文化大连</td>\n",
       "      <td>14</td>\n",
       "      <td>2.520000e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>95</td>\n",
       "      <td>龙王塘帆船出海观光</td>\n",
       "      <td>10.00</td>\n",
       "      <td>龙王塘樱花园</td>\n",
       "      <td>175</td>\n",
       "      <td>1.750000e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>14</td>\n",
       "      <td>新疆 和田玉 手镯 羊脂玉手镯子女款 冰种天然白玉石手镯带证书</td>\n",
       "      <td>998.00</td>\n",
       "      <td>最新推荐</td>\n",
       "      <td>1</td>\n",
       "      <td>9.980000e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>40</td>\n",
       "      <td>中远海运洲际酒店鲍鱼王子中餐厅-双人龙虾餐饭票</td>\n",
       "      <td>299.00</td>\n",
       "      <td>玩乐美食</td>\n",
       "      <td>3</td>\n",
       "      <td>8.970000e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>75</td>\n",
       "      <td>商务伴手礼，樱花酥，樱花树下，白头偕老</td>\n",
       "      <td>19.90</td>\n",
       "      <td>伴手大连</td>\n",
       "      <td>36</td>\n",
       "      <td>7.164000e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>73</td>\n",
       "      <td>商务伴手礼，槐花酥，又是一年槐花香，童年的味道</td>\n",
       "      <td>19.90</td>\n",
       "      <td>伴手大连</td>\n",
       "      <td>30</td>\n",
       "      <td>5.970000e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>32</td>\n",
       "      <td>海朴 淡干海参50g 大连刺参 底播干海参即食海参 臻鸾款</td>\n",
       "      <td>560.00</td>\n",
       "      <td>海参礼盒</td>\n",
       "      <td>1</td>\n",
       "      <td>5.600000e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>13</td>\n",
       "      <td>凤华 双耳铸铁炒锅老式铁锅无涂层不生锈圆底加厚生铁炖锅炒菜锅</td>\n",
       "      <td>185.00</td>\n",
       "      <td>最新推荐</td>\n",
       "      <td>3</td>\n",
       "      <td>5.550000e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>65</td>\n",
       "      <td>《小象芭芭拉的故事——西班牙钢琴家巴勃罗•加尔多音乐故事会》-大连站</td>\n",
       "      <td>60.00</td>\n",
       "      <td>文化大连</td>\n",
       "      <td>6</td>\n",
       "      <td>3.600000e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>1</td>\n",
       "      <td>青岛方特首届新春梦幻灯会来啦！夜场通玩票仅售89元！大年初一至十五，精彩上演不停歇！游方特，...</td>\n",
       "      <td>89.00</td>\n",
       "      <td>玩乐美食</td>\n",
       "      <td>4</td>\n",
       "      <td>3.560000e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>71</td>\n",
       "      <td>儿童剧《白雪公主》-大连站</td>\n",
       "      <td>80.00</td>\n",
       "      <td>文化大连</td>\n",
       "      <td>4</td>\n",
       "      <td>3.200000e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>44</td>\n",
       "      <td>牛牛九九草莓采摘园</td>\n",
       "      <td>45.00</td>\n",
       "      <td>最新推荐</td>\n",
       "      <td>7</td>\n",
       "      <td>3.150000e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>66</td>\n",
       "      <td>《激情与技艺——十二星座三重奏音乐会》-大连站</td>\n",
       "      <td>60.00</td>\n",
       "      <td>文化大连</td>\n",
       "      <td>5</td>\n",
       "      <td>3.000000e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>48</td>\n",
       "      <td>龙王塘樱花园散客票</td>\n",
       "      <td>20.00</td>\n",
       "      <td>龙王塘樱花园</td>\n",
       "      <td>14</td>\n",
       "      <td>2.800000e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>27</td>\n",
       "      <td>海狸先生海鲜零食吃货大礼包1150g儿童零食组合装过年礼盒</td>\n",
       "      <td>159.00</td>\n",
       "      <td>海狸先生</td>\n",
       "      <td>1</td>\n",
       "      <td>1.590000e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>52</td>\n",
       "      <td>【佳和温泉水世界】3.8女王节特惠，仅售29.9元！大连奢华汤泉单人浴资门票火爆预售，汤泉沐...</td>\n",
       "      <td>29.90</td>\n",
       "      <td>玩乐美食</td>\n",
       "      <td>5</td>\n",
       "      <td>1.495000e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>11</td>\n",
       "      <td>【三只松鼠_纸皮核桃210gx2袋】坚果特产薄皮大仁带壳核桃干果</td>\n",
       "      <td>32.90</td>\n",
       "      <td>餐饮</td>\n",
       "      <td>4</td>\n",
       "      <td>1.316000e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>39</td>\n",
       "      <td>大连森林动物园 电子门票 成人票/半价票【当天可用 扫码入园】</td>\n",
       "      <td>98.00</td>\n",
       "      <td>玩乐美食</td>\n",
       "      <td>1</td>\n",
       "      <td>9.800000e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>19</td>\n",
       "      <td>【三只松鼠_开心果225gX2袋】休闲孕妇零食坚果炒货干果无漂白</td>\n",
       "      <td>10.00</td>\n",
       "      <td>最新推荐</td>\n",
       "      <td>9</td>\n",
       "      <td>9.000000e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>34</td>\n",
       "      <td>海狸先生 醋昆布5袋装醋海带条裙带菜即食海带零食海带丝开袋即食</td>\n",
       "      <td>34.90</td>\n",
       "      <td>鲜鲜零食</td>\n",
       "      <td>2</td>\n",
       "      <td>6.980000e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>28</td>\n",
       "      <td>海狸先生鳕鱼肠50g*5根儿童深海迷你小鱼肠雪鱼拇指肠鳕鱼棒</td>\n",
       "      <td>21.80</td>\n",
       "      <td>海狸先生</td>\n",
       "      <td>3</td>\n",
       "      <td>6.540000e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>35</td>\n",
       "      <td>海狸先生扇贝裙边罐头90gX1罐大连海鲜虾夷贝肉罐头小吃零食拌饭</td>\n",
       "      <td>14.90</td>\n",
       "      <td>鲜鲜零食</td>\n",
       "      <td>4</td>\n",
       "      <td>5.960000e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>23</td>\n",
       "      <td>海狸先生海苔夹心脆40gX4罐海苔芝麻夹心脆夹心海苔即食儿童零食</td>\n",
       "      <td>53.60</td>\n",
       "      <td>海狸先生</td>\n",
       "      <td>1</td>\n",
       "      <td>5.360000e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>17</td>\n",
       "      <td>好利来</td>\n",
       "      <td>10.00</td>\n",
       "      <td>食品</td>\n",
       "      <td>2</td>\n",
       "      <td>2.000000e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>16</td>\n",
       "      <td>巧乐兹</td>\n",
       "      <td>2.50</td>\n",
       "      <td>食品</td>\n",
       "      <td>6</td>\n",
       "      <td>1.500000e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>21</td>\n",
       "      <td>海狸先生烤海苔40gX2罐拌饭海苔碎即食儿童炒海苔紫菜碎炸拌海苔</td>\n",
       "      <td>1.00</td>\n",
       "      <td>最新推荐</td>\n",
       "      <td>13</td>\n",
       "      <td>1.300000e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>20</td>\n",
       "      <td>海狸先生瑶柱丝罐头2罐海鲜罐头即食干贝丝扇贝肉调味拌饭酱零食</td>\n",
       "      <td>1.00</td>\n",
       "      <td>最新推荐</td>\n",
       "      <td>2</td>\n",
       "      <td>2.000000e+00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      0                                                  1        2       3  \\\n",
       "0    50                                        【二0三樱花园散客票】    27.00  龙王塘樱花园   \n",
       "1    51                                     【龙王塘樱花园节假日团队票】    17.00    最新推荐   \n",
       "2    53                                      【龙王塘樱花园平日团队票】    13.00  龙王塘樱花园   \n",
       "3    62                            【龙王塘樱花园散客平日电子票】需提前两小时订票    18.80  龙王塘樱花园   \n",
       "4    98                                        【二0三樱花园团队票】    21.00  龙王塘樱花园   \n",
       "5    96                        【龙王塘樱花园散客平日周末通用电子票】需提前两小时订票    18.88  龙王塘樱花园   \n",
       "6    54                                【龙王塘樱花园夜场票】需提前两小时订票     9.90  龙王塘樱花园   \n",
       "7    61                             大地艺术节+疯狂动物节+203樱花园 大套票    21.00  二0三樱花园   \n",
       "8    91                          平日 大地艺术节+疯狂动物节+龙王塘樱花园 大套票    13.01  龙王塘樱花园   \n",
       "9    92            龙王塘直通车—与樱共舞，来醉美大连，赏浪漫樱花。平日周末通用。需提前两小时订票    38.80  龙王塘樱花园   \n",
       "10   49                                          龙王塘樱花园团队票   200.00  龙王塘樱花园   \n",
       "11   89                                           【服务费15元】    15.00  龙王塘樱花园   \n",
       "12  101                          【二0三樱花园团体票】企事业单位团体票，10人一份   249.00  二0三樱花园   \n",
       "13   99           龙王塘樱花园学生票/老人票，持学生证/老年证无需换票，直接入园，需提前两小时订票    10.00  龙王塘樱花园   \n",
       "14   56                                  槐花饼，又是一年槐花香，童年的味道    38.00    伴手大连   \n",
       "15   76                                     樱桃饼，青春和美好的无限挂念    38.00    伴手大连   \n",
       "16   72                                      樱花饼，樱花树下，白头偕老    38.00    伴手大连   \n",
       "17   58                                     樱花贺卡，凝固时间，传情达义    29.90    周边小礼   \n",
       "18   57                           樱花风铃，樱花浪漫，许个愿吧，叮当叮当，就要实现    19.90    周边小礼   \n",
       "19  100                                      【二0三樱花园散客原价票】    30.00  二0三樱花园   \n",
       "20   97                        节假日  大地艺术节+疯狂动物节+龙王塘樱花园 大套票    17.01  龙王塘樱花园   \n",
       "21   74                                  蓝莓饼，遇见莓好，吃到最美的那一颗    38.00    伴手大连   \n",
       "22   15                  5.5寸安卓智能pda景区验券核销小票打印二维码扫描终端可二次开发  1299.00    最新推荐   \n",
       "23   63                                       话剧《开心晚宴》—大连站   180.00    文化大连   \n",
       "24   95                                          龙王塘帆船出海观光    10.00  龙王塘樱花园   \n",
       "25   14                    新疆 和田玉 手镯 羊脂玉手镯子女款 冰种天然白玉石手镯带证书   998.00    最新推荐   \n",
       "26   40                            中远海运洲际酒店鲍鱼王子中餐厅-双人龙虾餐饭票   299.00    玩乐美食   \n",
       "27   75                                商务伴手礼，樱花酥，樱花树下，白头偕老    19.90    伴手大连   \n",
       "28   73                            商务伴手礼，槐花酥，又是一年槐花香，童年的味道    19.90    伴手大连   \n",
       "29   32                      海朴 淡干海参50g 大连刺参 底播干海参即食海参 臻鸾款   560.00    海参礼盒   \n",
       "30   13                     凤华 双耳铸铁炒锅老式铁锅无涂层不生锈圆底加厚生铁炖锅炒菜锅   185.00    最新推荐   \n",
       "31   65                 《小象芭芭拉的故事——西班牙钢琴家巴勃罗•加尔多音乐故事会》-大连站    60.00    文化大连   \n",
       "32    1  青岛方特首届新春梦幻灯会来啦！夜场通玩票仅售89元！大年初一至十五，精彩上演不停歇！游方特，...    89.00    玩乐美食   \n",
       "33   71                                      儿童剧《白雪公主》-大连站    80.00    文化大连   \n",
       "34   44                                          牛牛九九草莓采摘园    45.00    最新推荐   \n",
       "35   66                            《激情与技艺——十二星座三重奏音乐会》-大连站    60.00    文化大连   \n",
       "36   48                                          龙王塘樱花园散客票    20.00  龙王塘樱花园   \n",
       "37   27                      海狸先生海鲜零食吃货大礼包1150g儿童零食组合装过年礼盒   159.00    海狸先生   \n",
       "38   52  【佳和温泉水世界】3.8女王节特惠，仅售29.9元！大连奢华汤泉单人浴资门票火爆预售，汤泉沐...    29.90    玩乐美食   \n",
       "39   11                   【三只松鼠_纸皮核桃210gx2袋】坚果特产薄皮大仁带壳核桃干果    32.90      餐饮   \n",
       "40   39                    大连森林动物园 电子门票 成人票/半价票【当天可用 扫码入园】    98.00    玩乐美食   \n",
       "41   19                   【三只松鼠_开心果225gX2袋】休闲孕妇零食坚果炒货干果无漂白    10.00    最新推荐   \n",
       "42   34                    海狸先生 醋昆布5袋装醋海带条裙带菜即食海带零食海带丝开袋即食    34.90    鲜鲜零食   \n",
       "43   28                     海狸先生鳕鱼肠50g*5根儿童深海迷你小鱼肠雪鱼拇指肠鳕鱼棒    21.80    海狸先生   \n",
       "44   35                   海狸先生扇贝裙边罐头90gX1罐大连海鲜虾夷贝肉罐头小吃零食拌饭    14.90    鲜鲜零食   \n",
       "45   23                   海狸先生海苔夹心脆40gX4罐海苔芝麻夹心脆夹心海苔即食儿童零食    53.60    海狸先生   \n",
       "46   17                                                好利来    10.00      食品   \n",
       "47   16                                                巧乐兹     2.50      食品   \n",
       "48   21                   海狸先生烤海苔40gX2罐拌饭海苔碎即食儿童炒海苔紫菜碎炸拌海苔     1.00    最新推荐   \n",
       "49   20                     海狸先生瑶柱丝罐头2罐海鲜罐头即食干贝丝扇贝肉调味拌饭酱零食     1.00    最新推荐   \n",
       "\n",
       "            4             5  \n",
       "0   119018916  3.213511e+09  \n",
       "1     2016356  3.427805e+07  \n",
       "2     1435016  1.865521e+07  \n",
       "3      127098  2.389442e+06  \n",
       "4       40288  8.460480e+05  \n",
       "5       40568  7.659238e+05  \n",
       "6       45435  4.498065e+05  \n",
       "7        9801  2.058210e+05  \n",
       "8       10625  1.382312e+05  \n",
       "9        1704  6.611520e+04  \n",
       "10        272  5.440000e+04  \n",
       "11       3000  4.500000e+04  \n",
       "12         98  2.440200e+04  \n",
       "13       2164  2.164000e+04  \n",
       "14        322  1.223600e+04  \n",
       "15        315  1.197000e+04  \n",
       "16        300  1.140000e+04  \n",
       "17        336  1.004640e+04  \n",
       "18        450  8.955000e+03  \n",
       "19        250  7.500000e+03  \n",
       "20        432  7.348320e+03  \n",
       "21        170  6.460000e+03  \n",
       "22          4  5.196000e+03  \n",
       "23         14  2.520000e+03  \n",
       "24        175  1.750000e+03  \n",
       "25          1  9.980000e+02  \n",
       "26          3  8.970000e+02  \n",
       "27         36  7.164000e+02  \n",
       "28         30  5.970000e+02  \n",
       "29          1  5.600000e+02  \n",
       "30          3  5.550000e+02  \n",
       "31          6  3.600000e+02  \n",
       "32          4  3.560000e+02  \n",
       "33          4  3.200000e+02  \n",
       "34          7  3.150000e+02  \n",
       "35          5  3.000000e+02  \n",
       "36         14  2.800000e+02  \n",
       "37          1  1.590000e+02  \n",
       "38          5  1.495000e+02  \n",
       "39          4  1.316000e+02  \n",
       "40          1  9.800000e+01  \n",
       "41          9  9.000000e+01  \n",
       "42          2  6.980000e+01  \n",
       "43          3  6.540000e+01  \n",
       "44          4  5.960000e+01  \n",
       "45          1  5.360000e+01  \n",
       "46          2  2.000000e+01  \n",
       "47          6  1.500000e+01  \n",
       "48         13  1.300000e+01  \n",
       "49          2  2.000000e+00  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Data = pd.read_csv(r\"goods.csv\", header=None)\n",
    "\n",
    "Data.sort_values([5],ascending=False).head(100)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 50 entries, 0 to 49\n",
      "Data columns (total 6 columns):\n",
      "0    50 non-null int64\n",
      "1    50 non-null object\n",
      "2    50 non-null float64\n",
      "3    50 non-null object\n",
      "4    50 non-null int64\n",
      "5    50 non-null float64\n",
      "dtypes: float64(2), int64(2), object(2)\n",
      "memory usage: 2.4+ KB\n"
     ]
    }
   ],
   "source": [
    "Data.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>2</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>50.000000</td>\n",
       "      <td>50.00000</td>\n",
       "      <td>5.000000e+01</td>\n",
       "      <td>5.000000e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>53.860000</td>\n",
       "      <td>106.31000</td>\n",
       "      <td>2.455086e+06</td>\n",
       "      <td>6.543087e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>28.703274</td>\n",
       "      <td>237.75176</td>\n",
       "      <td>1.682459e+07</td>\n",
       "      <td>4.543244e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.00000</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>29.000000</td>\n",
       "      <td>17.00250</td>\n",
       "      <td>4.000000e+00</td>\n",
       "      <td>1.892500e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>53.500000</td>\n",
       "      <td>29.90000</td>\n",
       "      <td>2.200000e+01</td>\n",
       "      <td>1.374000e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>73.750000</td>\n",
       "      <td>60.00000</td>\n",
       "      <td>4.455000e+02</td>\n",
       "      <td>2.371150e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>101.000000</td>\n",
       "      <td>1299.00000</td>\n",
       "      <td>1.190189e+08</td>\n",
       "      <td>3.213511e+09</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                0           2             4             5\n",
       "count   50.000000    50.00000  5.000000e+01  5.000000e+01\n",
       "mean    53.860000   106.31000  2.455086e+06  6.543087e+07\n",
       "std     28.703274   237.75176  1.682459e+07  4.543244e+08\n",
       "min      1.000000     1.00000  1.000000e+00  2.000000e+00\n",
       "25%     29.000000    17.00250  4.000000e+00  1.892500e+02\n",
       "50%     53.500000    29.90000  2.200000e+01  1.374000e+03\n",
       "75%     73.750000    60.00000  4.455000e+02  2.371150e+04\n",
       "max    101.000000  1299.00000  1.190189e+08  3.213511e+09"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Data.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0xa952940>"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "D:\\Program Files (x86)\\Microsoft Visual Studio\\Shared\\Anaconda3_64\\lib\\site-packages\\matplotlib\\font_manager.py:1328: UserWarning: findfont: Font family ['SeiHei'] not found. Falling back to DejaVu Sans\n",
      "  (prop.get_family(), self.defaultFamily[fontext]))\n"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYUAAAERCAYAAACU1LsdAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMi4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvhp/UCwAAFV1JREFUeJzt3X2QXfV93/H3dx+kpQgbgTYuZYUFtZJGYyvg7LgQPA22sS2oR7QFJ6JOcVIaxm2cNk2mBkKGOGQ6rUVcu5nBD6pLiT0Ego2DVSJHydgkdhOLahWDgoRlb8G2FtloLQRGBvS03/5xz/5ytewj2rP3Xu37NbOz5/zO7579nt/dvZ89D/fcyEwkSQLoanUBkqT2YShIkgpDQZJUGAqSpMJQkCQVhoIkqejIUIiIOyNif0Q8Nou+50XEQxHx9YjYGRFXLkSNktSJOjIUgLuAdbPs+1vAfZl5EbAB+FhdRUlSp+vIUMjMrwDPNLdFxD+MiD+NiB0R8dWI+Efj3YFXVdOvBvYtYKmS1FF6Wl3APNoEvC8zvxUR/5jGHsFbgQ8CfxYRvwqcDlzeuhIlqb2dEqEQEcuAnwE+GxHjzUur79cCd2XmhyPiEuAzEfH6zBxrQamS1NZOiVCgcRjs2cy8cJJl11Odf8jMr0VEH7AC2L+A9UlSR+jIcwoTZeYPgScj4t0A0fBT1eLvAm+r2n8S6ANGW1KoJLW56MS7pEbEPcBlNP7jfxr4beDLwMeBc4Be4N7MvC0i1gD/A1hG46TzBzLzz1pRtyS1u44MBUlSPU6Jw0eSpPnRcSeaV6xYkatWrWp1GZLUUXbs2PGDzOyfqV/HhcKqVasYGhpqdRmS1FEi4juz6efhI0lSYShIkgpDQZJU1BYKM93eOiLeU93KemdE/HXTm80kSS1S557CXUx/e+sngZ/NzLXA79K4oZ0kqYVqC4XJbm89YflfZ+bBanYbMFBXLTM5cOgwj+59lgOHDreqBElqC+1ySer1wBdb8YO/8MhT3Hj/Tnq7ujg6NsbGq9ey/sJzW1GKJLVcy080R8RbaITCjdP0uSEihiJiaHR0/u5ld+DQYW68fycvHR3j+cPHeOnoGB+4f6d7DJIWrZaGQkSsBT4FXJWZB6bql5mbMnMwMwf7+2d8Q96sjRx8kd6uE4egt6uLkYMvztvPkKRO0rJQiIjzgM8D/yozv9mKGgaWn8bRsRM/a+fo2BgDy09rRTmS1HJ1XpJ6D/A14CciYiQiro+I90XE+6outwJnAx+LiEciYsHvXXH2sqVsvHotfb1dnLG0h77eLjZevZazly2d+cGSdArquFtnDw4O5nzf++jAocOMHHyRgeWnGQiSTkkRsSMzB2fq1y5XH7XU2cuWGgaSRBtcfSRJah+GgiSpMBQkSYWhIEkqDAVJUmEoSJIKQ0GSVBgKkqTCUJAkFYaCJKkwFCRJhaEgSSoMBUlSYShIkgpDQZJUGAqSpMJQkCQVhoIkqTAUJEmFoSBJKgwFSVJhKEiSCkNBklQYCpKkorZQiIg7I2J/RDw2xfKIiN+PiOGI2BkRb6yrFknS7NS5p3AXsG6a5VcAq6uvG4CP11iLJGkWaguFzPwK8Mw0Xa4CPp0N24AzI+KcuuqRJM2slecUzgX2Ns2PVG0vExE3RMRQRAyNjo4uSHGStBi1MhRikracrGNmbsrMwcwc7O/vr7ksSVq8WhkKI8DKpvkBYF+LapEk0dpQ2AxcV12FdDHwXGZ+r4X1SNKi11PXiiPiHuAyYEVEjAC/DfQCZOYngC3AlcAw8ALwS3XVIkmandpCITOvnWF5Ar9S18+XJM2d72iWJBWGgiSpMBQkSYWhIEkqDAVJUmEoSJIKQ0GSVBgKkqTCUJAkFYaCJKkwFCRJhaEgSSoMBUlSYShIkgpDQZJUGAqSpMJQkCQVhoIkqTAUJEmFoSBJKgwFSVJhKEiSCkNBklQYCpKkotZQiIh1EbEnIoYj4qZJlp8XEQ9FxNcjYmdEXFlnPZKk6dUWChHRDdwBXAGsAa6NiDUTuv0WcF9mXgRsAD5WVz2SpJnVuafwJmA4M5/IzCPAvcBVE/ok8Kpq+tXAvhrrkSTNoM5QOBfY2zQ/UrU1+yDwCxExAmwBfnWyFUXEDRExFBFDo6OjddQqSaLeUIhJ2nLC/LXAXZk5AFwJfCYiXlZTZm7KzMHMHOzv76+hVEkS1BsKI8DKpvkBXn546HrgPoDM/BrQB6yosSZJ0jTqDIXtwOqIOD8iltA4kbx5Qp/vAm8DiIifpBEKHh+SpBapLRQy8xjwfmAr8DiNq4x2RcRtEbG+6vYbwC9HxKPAPcAvZubEQ0ySpAXSU+fKM3MLjRPIzW23Nk3vBi6tswZJ0uz5jmZJUmEoSJIKQ0GSVBgKkqTCUJAkFYaCJKkwFCRJhaEgSSoMBUlSYShIkgpDQZJUGAqSpMJQkCQVhoIkqTAUJEmFoSBJKgwFSVJhKEiSCkNBklQYCpKkwlCQJBWGgiSpMBQkSYWhIEkqag2FiFgXEXsiYjgibpqiz89FxO6I2BURf1hnPZKk6fXUteKI6AbuAN4OjADbI2JzZu5u6rMauBm4NDMPRsSP1VWPJGlmde4pvAkYzswnMvMIcC9w1YQ+vwzckZkHATJzf431SJJmMOdQiIhPz7LrucDepvmRqq3ZjwM/HhF/FRHbImLdFD/zhogYioih0dHRuZYsSZqlaQ8fRcTmiU3AWyLiTIDMXD/dwydpy0l+/mrgMmAA+GpEvD4znz3hQZmbgE0Ag4ODE9chSZonM51TGAB2A5+i8YIewCDw4VmsewRYOWFd+ybpsy0zjwJPRsQeGiGxfRbrlyTNs5kOHw0CO4BbgOcy8y+AFzPzLzPzL2d47HZgdUScHxFLgA3AxD2PB4C3AETEChqHk56Y2yZIkubLtHsKmTkGfCQiPlt9f3qmxzQ99lhEvB/YCnQDd2bmroi4DRjKzM3VsndExG7gOPCfMvPASWyPJOkkRObsD9FHxD+lcfnob9ZX0vQGBwdzaGioVT9ekjpSROzIzMGZ+s3pfQqZ+SfAn7ziqiRJbc3bXEiSCkNBklQYCpKkwlCQJBWGgiSpMBQkSYWhIEkqDAVJUmEoSJIKQ0GSVBgKkqTCUJAkFYaCJKkwFCRJhaEgSSoMBUlSYShIkgpDQZJUGAqSpMJQkCQVhoIkqTAUJEmFoSBJKmoNhYhYFxF7ImI4Im6apt81EZERMVhnPZKk6dUWChHRDdwBXAGsAa6NiDWT9DsD+PfAw3XVIkmanTr3FN4EDGfmE5l5BLgXuGqSfr8LbAReqrEWSdIs1BkK5wJ7m+ZHqrYiIi4CVmbmg9OtKCJuiIihiBgaHR2d/0olSUC9oRCTtGVZGNEFfAT4jZlWlJmbMnMwMwf7+/vnsURJUrM6Q2EEWNk0PwDsa5o/A3g98BcR8W3gYmCzJ5slqXXqDIXtwOqIOD8ilgAbgM3jCzPzucxckZmrMnMVsA1Yn5lDNdYkSZpGbaGQmceA9wNbgceB+zJzV0TcFhHr6/q5kqRXrqfOlWfmFmDLhLZbp+h7WZ21SJJm5juaJUmFoSBJKgwFSVJhKEiSCkNBklQYCpKkwlCQJBWGgiSpMBQkSYWhIEkqDAVJUmEoSJIKQ0GSVBgKkqTCUJAkFYaCJKkwFCRJhaEgSSoMBUlSYShIkgpDQZJUGAqSpMJQkCQVhoIkqTAUJElFraEQEesiYk9EDEfETZMs//WI2B0ROyPiSxHx2jrrkSRNr7ZQiIhu4A7gCmANcG1ErJnQ7evAYGauBT4HbKyrHknSzOrcU3gTMJyZT2TmEeBe4KrmDpn5UGa+UM1uAwZqrEeSNIM6Q+FcYG/T/EjVNpXrgS9OtiAiboiIoYgYGh0dnccSJUnN6gyFmKQtJ+0Y8QvAIHD7ZMszc1NmDmbmYH9//zyWKElq1lPjukeAlU3zA8C+iZ0i4nLgFuBnM/NwjfVIkmZQ557CdmB1RJwfEUuADcDm5g4RcRHwSWB9Zu6vsRZJ0izUFgqZeQx4P7AVeBy4LzN3RcRtEbG+6nY7sAz4bEQ8EhGbp1idJGkB1Hn4iMzcAmyZ0HZr0/Tldf58SdLc+I5mSVJhKEiSCkNBklQYCpKkwlCQJBWGgiSpMBQkSYWhIEkqDAVJUmEoSJIKQ0GSVBgKkqTCUJAkFYaCJKkwFCRJhaEgSSoMBUlSYShIkgpDQZJUGAqSpMJQkCQVizYUDhw6zKN7n+XAocOtLkWS2kZPqwtohbu3fYff+d+76O3u4ngmG69ey/oLz211WZLUcotuT+Hubd/hlgce48jx5EdHjvPS0TE+cP9O9xgkiZr3FCJiHfDfgW7gU5n5XycsXwp8Gvhp4ADw85n57TpqGX76ebbu+j4f/vNvvmzZS0fHuOWPd3Ls+BiHDo/xrjf8fd6wcjmnL+nmG99/nh8cOsybX7eC173mDKBx6Gnk4IucvqSbHx05Xr4PLD+Ns5ctnXVN4+tpftzEdQ8sPw3gZf3mut756HuqWIzb3Cl8bqa2UGNTWyhERDdwB/B2YATYHhGbM3N3U7frgYOZ+bqI2AB8CPj5+a7l1gf+lk9v++60ff501/4yve3JZybtc90l5/HTrz2LG+/fCTTCpDvgeEJfb2Ona7aHor7wyFPceP9Oeru6ODo2xsar15LAjffvJMeSw8eTvt4ujo8lmclpvT2l33Trn2y9U/WfS99TxWLc5k7hczO1hRybyMx6VhxxCfDBzHxnNX8zQGb+l6Y+W6s+X4uIHuD7QH9OU9Tg4GAODQ3Nuo7hp5/n8o985RVuxcst6Q6OHJ96zPp6u/irG986bZIfOHSYSz/0ZV46OlbalvZ0AcnhY9M/H9Otf7L1TtV/Ln1PFYtxmzuFz83U5mtsImJHZg7O1K/OcwrnAnub5keqtkn7ZOYx4Dng7IkriogbImIoIoZGR0fnVMQje5+dU/+ZRMS0y3u7uhg5+OK0fUYOvkhv14lD390VdMfMT8d0659svVP1n0vfU8Vi3OZO4XMztYUemzpDYbJXz4n/Bs+mD5m5KTMHM3Owv79/TkVcuPLMOfWfyUx7VkfHxsp5gKkMLD+No2NjJ7QdH0uO59gUj5jd+idb71T959L3VLEYt7lT+NxMbaHHps5QGAFWNs0PAPum6lMdPno1MPkB/Vfoda85g+suOW9e1nXdJefxe+/+Kfp6u8o5hO4q1sbbNl69dsZdurOXLWXj1Wvp6+3ijKU99PV2cfs1a7n9msa6l1Yr7evtorc76Omi9Jtu/ZOtd6r+c+l7qliM29wpfG6mttBjU+c5hR7gm8DbgKeA7cC/zMxdTX1+BXhDZr6vOtH8LzLz56Zb71zPKYwbfvp5/s/wKCuW9fHUMz/igUf38cMXjvDisTEuveAsXnV6H08/94JXHy0Ci3GbO4XPzdROdmxme06htlCoirgS+CiNS1LvzMz/HBG3AUOZuTki+oDPABfR2EPYkJlPTLfOVxoKkrSYzTYUan2fQmZuAbZMaLu1afol4N111iBJmr1F945mSdLUDAVJUmEoSJIKQ0GSVNR69VEdImIU+M4rfPgK4AfzWM5CsvbWsPbWsPb599rMnPHdvx0XCicjIoZmc0lWO7L21rD21rD21vHwkSSpMBQkScViC4VNrS7gJFh7a1h7a1h7iyyqcwqSpOkttj0FSdI0DAVJUrFoQiEi1kXEnogYjoibWl1Ps4hYGREPRcTjEbErIv5D1X5WRPx5RHyr+r68ao+I+P1qW3ZGxBtbuwWNz+SOiK9HxIPV/PkR8XBV+x9FxJKqfWk1P1wtX9Xius+MiM9FxDeq8b+kU8Y9Iv5j9fvyWETcExF97TruEXFnROyPiMea2uY8zhHx3qr/tyLivS2s/fbqd2ZnRPxxRJzZtOzmqvY9EfHOpva2fQ06QWae8l80bt39/4ALgCXAo8CaVtfVVN85wBur6TNofA7FGmAjcFPVfhPwoWr6SuCLND657mLg4TbYhl8H/hB4sJq/j8at0AE+AfzbavrfAZ+opjcAf9Tiuv8A+DfV9BLgzE4YdxofZfskcFrTeP9iu4478E+ANwKPNbXNaZyBs4Anqu/Lq+nlLar9HUBPNf2hptrXVK8vS4Hzq9ed7nZ/DTphe1tdwAL9Ql4CbG2avxm4udV1TVPvF4C3A3uAc6q2c4A91fQngWub+pd+Lap3APgS8FbgweqP+QdNfzRl/IGtwCXVdE/VL1pU96uqF9aY0N72487ffb75WdU4Pgi8s53HHVg14YV1TuMMXAt8sqn9hH4LWfuEZf8cuLuaPuG1ZXzcO+k1aLEcPhr/Axo3UrW1nWq3/iLgYeA1mfk9gOr7j1Xd2m17Pgp8ABj/INmzgWcz81g131xfqb1a/lzVvxUuAEaB/1Ud+vpURJxOB4x7Zj4F/B7wXeB7NMZxB50x7uPmOs5tM/4T/GsaezbQebW/zGIJhZikre2uxY2IZcD9wK9l5g+n6zpJW0u2JyLeBezPzB3NzZN0zVksW2g9NA4LfDwzLwJ+ROMwxlTapvbq+PtVNA5R/APgdOCKSbq247jPZKpa224bIuIW4Bhw93jTJN3asvapLJZQGAFWNs0PAPtaVMukIqKXRiDcnZmfr5qfjohzquXnAPur9nbankuB9RHxbeBeGoeQPgqcGY3P6YYT6yu1V8tfTeOjWFthBBjJzIer+c/RCIlOGPfLgSczczQzjwKfB36Gzhj3cXMd53Yaf6oT3e8C3pPVMSE6pPbpLJZQ2A6srq7MWELjRNvmFtdUREQA/xN4PDP/W9OizcD4FRbvpXGuYbz9uuoqjYuB58Z3wxdaZt6cmQOZuYrGuH45M98DPARcU3WbWPv4Nl1T9W/Jf0yZ+X1gb0T8RNX0NmA3HTDuNA4bXRwRf6/6/Rmvve3Hvclcx3kr8I6IWF7tKb2jaltwEbEOuBFYn5kvNC3aDGyorvY6H1gN/F/a/DXoBK0+qbFQXzSuaPgmjSsAbml1PRNqezONXcmdwCPV15U0jvl+CfhW9f2sqn8Ad1Tb8rfAYKu3oarrMv7u6qMLaPwxDAOfBZZW7X3V/HC1/IIW13whMFSN/QM0rmrpiHEHfgf4BvAY8BkaV7y05bgD99A493GUxn/N17+ScaZx/H64+vqlFtY+TOMcwfjf6yea+t9S1b4HuKKpvW1fg5q/vM2FJKlYLIePJEmzYChIkgpDQZJUGAqSpMJQkCQVhoJ0kmKKu9xKnchLUqWTVL0b95zM/JuIOIPGPYj+WWbubnFp0py5pyCdpMz8Xmb+TTX9PPA4bXqzM2kmhoI0jybc5VbqOIaCNE/mcJdbqW0ZCtI8mOIut1LH8USzdJKqu5T+AfBMZv5aq+uRToahIJ2kiHgz8FUad/Qc//S538zMLa2rSnplDAVJUuE5BUlSYShIkgpDQZJUGAqSpMJQkCQVhoIkqTAUJEnF/wfhZb4QUZUqyQAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "Data.plot.scatter(x=2,y=4)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0xa9527b8>"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "D:\\Program Files (x86)\\Microsoft Visual Studio\\Shared\\Anaconda3_64\\lib\\site-packages\\matplotlib\\font_manager.py:1328: UserWarning: findfont: Font family ['SeiHei'] not found. Falling back to DejaVu Sans\n",
      "  (prop.get_family(), self.defaultFamily[fontext]))\n"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYUAAAERCAYAAACU1LsdAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMi4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvhp/UCwAAFQxJREFUeJzt3X+wXGd93/H350qyZBBgxxIZkEzsFCfgUGPTOxTiTGN+tbbDyJ2aH3ZDSRk3HmZwkrY02CQZIM5kUkwpSSaGxCWuA23tGswElRicDpBACGZ8HYOK7ZhoDEEXE3wRshODLUvo2z929bC+uj92pXu00t73a0ajPc8+55zvc87u/dxz9uy5qSokSQKYGncBkqRjh6EgSWoMBUlSYyhIkhpDQZLUGAqSpOa4DIUk1yd5MMmXh+j7rCSfTnJXkh1JLjwaNUrS8ei4DAXgBuD8Ifv+GnBzVZ0DXAK8t6uiJOl4d1yGQlV9BvjOYFuSf5TkE0nuTPLZJM852B14av/x04AHjmKpknRcWTvuAlbQdcAbq+pvkvxTekcELwXeAfxpkl8Angy8fHwlStKxbSJCIclG4CeBDyU52Ly+//+lwA1V9e4kLwY+mOR5VXVgDKVK0jFtIkKB3mmwh6rq7AWeu4z+5w9V9fkkG4BNwINHsT5JOi4cl58pzFdVfw98NcmrAdLz/P7TXwde1m9/LrABmBtLoZJ0jMvxeJfUJDcC59H7jf9bwNuBTwHvA54BrANuqqqrk5wJ/DdgI70Pnd9SVX86jrol6Vh3XIaCJKkbE3H6SJK0Mo67D5o3bdpUp5122rjLkKTjyp133vntqtq8XL/jLhROO+00ZmZmxl2GJB1XkvztMP08fSRJagwFSVJjKEiSms5CYbnbWyf52f6trHck+cuBL5tJksakyyOFG1j69tZfBX66qs4CfoPeDe0kSWPUWSgsdHvrec//ZVXt6U/eDmztqhapK7sf2cuXdj3E7kf2jrsUaUUcK5ekXgZ8fNxFSKP46Be/wZW37GDd1BT7DhzgmovPYtvZW8ZdlnRExv5Bc5KX0AuFK5foc3mSmSQzc3Pey07jt/uRvVx5yw4e23eAf9i7n8f2HeAtt+zwiEHHvbGGQpKzgPcDF1XV7sX6VdV1VTVdVdObNy/7hTypc7N7HmXd1BPfPuumppjd8+iYKpJWxthCIcmzgI8A/6aqvjKuOqTDsfXkE9l34Il/p2nfgQNsPfnEMVUkrYwuL0m9Efg88ONJZpNcluSNSd7Y7/I24BTgvUm+mMR7V+i4ccrG9Vxz8VlsWDfFU9avZcO6Ka65+CxO2bh++ZmlY9hxd+vs6enp8t5HOlbsfmQvs3seZevJJxoIOqYlubOqppfrd6xcfSQdl07ZuN4w0EQZ+9VHkqRjh6EgSWoMBUlSYyhIkhpDQZLUGAqSpMZQkCQ1hoIkqTEUJEmNoSBJagwFSVJjKEiSGkNBktQYCpKkxlCQJDWGgiSpMRQkSY2hIElqDAVJUmMoSJIaQ0GS1BgKkqTGUJAkNYaCJKnpLBSSXJ/kwSRfXuT5JPndJDuT7Ejygq5qkSQNp8sjhRuA85d4/gLgjP6/y4H3dViLJGkInYVCVX0G+M4SXS4CPlA9twMnJXlGV/VIkpY3zs8UtgC7BqZn+22HSHJ5kpkkM3Nzc0elOElajcYZClmgrRbqWFXXVdV0VU1v3ry547IkafUaZyjMAqcOTG8FHhhTLZIkxhsK24HX969CehHwcFV9c4z1SNKqt7arBSe5ETgP2JRkFng7sA6gqn4fuBW4ENgJfA94Q1e1SJKG01koVNWlyzxfwJu6Wr8kaXR+o1mS1BgKkqTGUJAkNYaCJKkxFCRJjaEgSWoMBUlSYyhIkhpDQZLUGAqSpMZQkCQ1hoIkqTEUJEmNoSBJagwFSVJjKEiSGkNBktQYCpKkxlCQJDWGgiSpMRQkSY2hIElqDAVJUmMoSJKaTkMhyflJ7kuyM8lVCzz/rCSfTnJXkh1JLuyyHknS0joLhSRrgGuBC4AzgUuTnDmv268BN1fVOcAlwHu7qkeStLwujxReCOysqvur6nHgJuCieX0KeGr/8dOABzqsR5K0jC5DYQuwa2B6tt826B3A65LMArcCv7DQgpJcnmQmyczc3FwXtUqS6DYUskBbzZu+FLihqrYCFwIfTHJITVV1XVVNV9X05s2bOyhVkgTdhsIscOrA9FYOPT10GXAzQFV9HtgAbOqwJknSEroMhTuAM5KcnuQEeh8kb5/X5+vAywCSPJdeKHh+SJLGpLNQqKr9wBXAbcC99K4yujvJ1Um29bu9Gfj5JF8CbgT+bVXNP8UkSTpK1na58Kq6ld4HyINtbxt4fA9wbpc1SJKG5zeaJUmNoSBJagwFSVJjKEiSGkNBktQYCpKkxlCQJDWGgiSpMRQkSY2hIElqDAVJUmMoSJIaQ0GS1BgKkqTGUJAkNYaCJKkxFCRJjaEgSWoMBUlSYyhIkhpDQZLUGAqSpMZQkCQ1hoIkqek0FJKcn+S+JDuTXLVIn9ckuSfJ3Un+V5f1SJKWtrarBSdZA1wLvAKYBe5Isr2q7hnocwbwVuDcqtqT5Old1SNJWl6XRwovBHZW1f1V9ThwE3DRvD4/D1xbVXsAqurBDuuRJC1j5FBI8oEhu24Bdg1Mz/bbBv0Y8GNJPpfk9iTnL7LOy5PMJJmZm5sbtWRJ0pCWPH2UZPv8JuAlSU4CqKptS82+QFstsP4zgPOArcBnkzyvqh56wkxV1wHXAUxPT89fhiRphSz3mcJW4B7g/fR+oAeYBt49xLJngVPnLeuBBfrcXlX7gK8muY9eSNwxxPIlSStsudNH08CdwK8CD1fVnwGPVtWfV9WfLzPvHcAZSU5PcgJwCTD/yOOPgZcAJNlE73TS/aMNQZK0UpY8UqiqA8B7knyo//+3lptnYN79Sa4AbgPWANdX1d1JrgZmqmp7/7l/nuQe4PvAL1fV7iMYjyTpCKRq+FP0SX6G3uWjv9JdSUubnp6umZmZca1eko5LSe6squnl+o30PYWq+hPgTw67KknSMc3bXEiSGkNBktQYCpKkxlCQJDWGgiSpMRQkSY2hIElqDAVJUmMoSJIaQ0GS1BgKkqTGUJAkNYaCJKkxFCRJjaEgSWoMBUlSYyhIkhpDQZLUGAqSpMZQkCQ1hoIkqTEUJEmNoSBJajoNhSTnJ7kvyc4kVy3R71VJKsl0l/VIkpbWWSgkWQNcC1wAnAlcmuTMBfo9BfhF4Atd1SJJGk6XRwovBHZW1f1V9ThwE3DRAv1+A7gGeKzDWiRJQ+gyFLYAuwamZ/ttTZJzgFOr6mNLLSjJ5UlmkszMzc2tfKWSJKDbUMgCbdWeTKaA9wBvXm5BVXVdVU1X1fTmzZtXsERJ0qAuQ2EWOHVgeivwwMD0U4DnAX+W5GvAi4DtftgsSePTZSjcAZyR5PQkJwCXANsPPllVD1fVpqo6rapOA24HtlXVTIc1SZKW0FkoVNV+4ArgNuBe4OaqujvJ1Um2dbVeSdLhW9vlwqvqVuDWeW1vW6TveV3WIklant9oliQ1hoIkqTEUJEmNoSBJagwFSVJjKEiSGkNBktQYCpKkxlCQJDWGgiSpMRQkSY2hIElqDAVJUmMoSJIaQ0GS1BgKkqTGUJAkNYaCJKkxFCRJjaEgSWoMBUlSYyhIkhpDQZLUGAqSpMZQkCQ1nYZCkvOT3JdkZ5KrFnj+Pya5J8mOJJ9M8iNd1iNJWlpnoZBkDXAtcAFwJnBpkjPndbsLmK6qs4APA9d0VY8kaXldHim8ENhZVfdX1ePATcBFgx2q6tNV9b3+5O3A1g7rkSQto8tQ2ALsGpie7bct5jLg4ws9keTyJDNJZubm5lawREnSoC5DIQu01YIdk9cB08C7Fnq+qq6rqumqmt68efMKlihJGrS2w2XPAqcOTG8FHpjfKcnLgV8Ffrqq9nZYjyRpGV0eKdwBnJHk9CQnAJcA2wc7JDkH+ANgW1U92GEtkqQhdBYKVbUfuAK4DbgXuLmq7k5ydZJt/W7vAjYCH0ryxSTbF1mcJOko6PL0EVV1K3DrvLa3DTx+eZfrlySNxm80S5IaQ0GS1BgKkqTGUJAkNYaCJKkxFCRJjaEgSWoMBUlSYyhIkhpDQZLUGAqSpMZQkCQ1hoIkqTEUJEmNoSBJagwFSVJjKEiSGkNBktQYCpKkxlCQJDWGgiSpMRSkFbL7kb18addD7H5k77hLkQ7b2nEXIE2Cj37xG1x5yw7WTU2x78ABrrn4LLadvQXohcXsnkfZevKJnLJx/ZgrlZZmKEhHaPcje7nylh08tu8Aj3EAgLfcsoNzn72Jv9j57UXDQjoWdRoKSc4HfgdYA7y/qv7zvOfXAx8A/gmwG3htVX2ti1rG+dvaYusebAdGejzqchbrP+y2WGwdw8w/6vhHXeZK1TNs//nTs3seZd3UVAsEgDUJ/+dLD/BbH7+XvfurPffLH/4SJz1pHT/xzKcd0T4cZlssNu+RbLtht8tidYw6tnFZydfskWyXxR53ub06C4Uka4BrgVcAs8AdSbZX1T0D3S4D9lTVs5NcArwTeO1K17LUoX3XFlv3YPtj+79PVXHiurVPePzovv0kYcPaNU9oX2w5o/Yfdlssto5h5h9m/EeyzMXGOWo9w/Z/zfRWbp6ZfcL85z57E/sOHHjCfN99/Pu88xN/zd799YT2vfuLN/6Pv+JA1WHvw2G2xWLb9Ei2+7DbZbExjDq2cVnJ1+ww+2ex9nFtr1TV8r0OZ8HJi4F3VNW/6E+/FaCqfmugz239Pp9Pshb4O2BzLVHU9PR0zczMDF3H7kf2cu47P8Vj+37wpt2wborPXfnSzn87WWzdH7vip3jl7/3FE9pHNepyFuu/3LZYaAzzl7vY/Ic7/lGXeaT1HO66Buf/3M5v85ZbdrAm4buPf3/R/vPnHXUfDtY6TH2jrGvY98Uo6x3W0XpPLmclX7NdbKel1recJHdW1fRy/bq8+mgLsGtgerbftmCfqtoPPAycMn9BSS5PMpNkZm5ubqQiDh7aD1o3NcXsnkdHWs7hWGzdX9z10CHtoxp1OYv1X25bLDSGYec/3PGPuswjredw1zU4/7azt/C5K1/Kr2/7CTauX3NIv/VrDl3O4ezDwVqHqW+UdQ37vhhlvcM6Wu/J5azka7aL7bTU+lZKl6GQBdrmHwEM04equq6qpqtqevPmzSMVsfXkEw85tN934EA7R9elxdZ99qknHdI+qlGXs1j/5bbFQmMYdv7DHf+oyzzSeg53XfPnP2Xjel7ynKez/8ATX8Lr107x7tc8n/Vrpw6Zd9R9OFjrMPWNsq5h3xejrHdYR+s9uZyVfM12sZ2WWt9K6TIUZoFTB6a3Ag8s1qd/+uhpwHdWsohTNq7nmovPYsO6KZ6yfi0b1k1xzcVnHZXD1MXW/ewffsoT2tetCWunOOTx2ilYtyaHtC+2nFH7D7Mt5o9hcB3LzT/s+I9kmQuNc9R6Run/+hc/a8n5F5rnXa86i1c+/5m861WjbYvlxrbUtlhomx7Jdh9luyw2hlHGNi4r+Zoddv8s1j6u7dXlZwprga8ALwO+AdwB/Ouqunugz5uAf1xVb+x/0Pyvquo1Sy131M8UDvLqI68+Wq6eYfsPM/8wY/bqI68+Oprba9jPFDoLhX4RFwK/Te+S1Our6jeTXA3MVNX2JBuADwLn0DtCuKSq7l9qmYcbCpK0mg0bCp1+T6GqbgVundf2toHHjwGv7rIGSdLwvPeRJKkxFCRJjaEgSWoMBUlS0+nVR11IMgf87QizbAK+3VE5xyrHvDo45tVhpcb8I1W17Ld/j7tQGFWSmWEuw5okjnl1cMyrw9Ees6ePJEmNoSBJalZDKFw37gLGwDGvDo55dTiqY574zxQkScNbDUcKkqQhGQqSpGaiQyHJ+UnuS7IzyVXjrqcLSU5N8ukk9ya5O8kv9dt/KMn/TfI3/f9PHnetKynJmiR3JflYf/r0JF/oj/d/Jzlh3DWupCQnJflwkr/u7+sXr4J9/B/6r+kvJ7kxyYZJ289Jrk/yYJIvD7QtuF/T87v9n2c7krygi5omNhSSrAGuBS4AzgQuTXLmeKvqxH7gzVX1XOBFwJv647wK+GRVnQF8sj89SX4JuHdg+p3Ae/rj3QNcNpaquvM7wCeq6jnA8+mNfWL3cZItwC8C01X1PHq337+EydvPNwDnz2tbbL9eAJzR/3c58L4uCprYUABeCOysqvur6nHgJuCiMde04qrqm1X1V/3H/0Dvh8UWemP9o363PwL+5XgqXHlJtgI/A7y/Px3gpcCH+10mbbxPBf4Z8IcAVfV4VT3EBO/jvrXAif0/2PUk4JtM2H6uqs9w6F+bXGy/XgR8oHpuB05K8oyVrmmSQ2ELsGtgerbfNrGSnEbvDxZ9Afjhqvom9IIDePr4Kltxvw28BTj4B3BPAR6qqv396Unb1z8KzAH/vX/K7P1JnswE7+Oq+gbwX4Cv0wuDh4E7mez9fNBi+/Wo/Eyb5FDIAm0Te/1tko3ALcC/r6q/H3c9XUnySuDBqrpzsHmBrpO0r9cCLwDeV1XnAN9lgk4VLaR/Hv0i4HTgmcCT6Z0+mW+S9vNyjsrrfJJDYRY4dWB6K/DAmGrpVJJ19ALhf1bVR/rN3zp4aNn//8Fx1bfCzgW2JfkavVOCL6V35HBS/zQDTN6+ngVmq+oL/ekP0wuJSd3HAC8HvlpVc1W1D/gI8JNM9n4+aLH9elR+pk1yKNwBnNG/WuEEeh9SbR9zTSuufz79D4F7q+q/Djy1Hfi5/uOfAz56tGvrQlW9taq2VtVp9Pbpp6rqZ4FPA6/qd5uY8QJU1d8Bu5L8eL/pZcA9TOg+7vs68KIkT+q/xg+OeWL384DF9ut24PX9q5BeBDx88DTTSprobzQnuZDeb5FrgOur6jfHXNKKS/JTwGeB/8cPzrH/Cr3PFW4GnkXvDfbqqpr/gdZxLcl5wH+qqlcm+VF6Rw4/BNwFvK6q9o6zvpWU5Gx6H6yfANwPvIHeL3UTu4+T/DrwWnpX2N0F/Dt659AnZj8nuRE4j97tsb8FvB34YxbYr/1w/D16Vyt9D3hDVc2seE2THAqSpNFM8ukjSdKIDAVJUmMoSJIaQ0GS1BgKkqTGUJBWwGq4I69WBy9JlY5Q/468XwFeQe9bp3cAl1bVPWMtTDoMHilIR25V3JFXq4OhIB25VXdHXk0uQ0E6cpN+l1atIoaCdORWzR15NfkMBenIrYo78mp1WLt8F0lLqar9Sa4AbuMHd+S9e8xlSYfFS1IlSY2njyRJjaEgSWoMBUlSYyhIkhpDQZLUGAqSpMZQkCQ1/x/m26pD55zR+QAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "Data.plot.scatter(x=0,y=4)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>50</td>\n",
       "      <td>【二0三樱花园散客票】</td>\n",
       "      <td>27.00</td>\n",
       "      <td>龙王塘樱花园</td>\n",
       "      <td>119018916</td>\n",
       "      <td>3.213511e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>51</td>\n",
       "      <td>【龙王塘樱花园节假日团队票】</td>\n",
       "      <td>17.00</td>\n",
       "      <td>最新推荐</td>\n",
       "      <td>2016356</td>\n",
       "      <td>3.427805e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>53</td>\n",
       "      <td>【龙王塘樱花园平日团队票】</td>\n",
       "      <td>13.00</td>\n",
       "      <td>龙王塘樱花园</td>\n",
       "      <td>1435016</td>\n",
       "      <td>1.865521e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>62</td>\n",
       "      <td>【龙王塘樱花园散客平日电子票】需提前两小时订票</td>\n",
       "      <td>18.80</td>\n",
       "      <td>龙王塘樱花园</td>\n",
       "      <td>127098</td>\n",
       "      <td>2.389442e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>54</td>\n",
       "      <td>【龙王塘樱花园夜场票】需提前两小时订票</td>\n",
       "      <td>9.90</td>\n",
       "      <td>龙王塘樱花园</td>\n",
       "      <td>45435</td>\n",
       "      <td>4.498065e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>96</td>\n",
       "      <td>【龙王塘樱花园散客平日周末通用电子票】需提前两小时订票</td>\n",
       "      <td>18.88</td>\n",
       "      <td>龙王塘樱花园</td>\n",
       "      <td>40568</td>\n",
       "      <td>7.659238e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>98</td>\n",
       "      <td>【二0三樱花园团队票】</td>\n",
       "      <td>21.00</td>\n",
       "      <td>龙王塘樱花园</td>\n",
       "      <td>40288</td>\n",
       "      <td>8.460480e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>91</td>\n",
       "      <td>平日 大地艺术节+疯狂动物节+龙王塘樱花园 大套票</td>\n",
       "      <td>13.01</td>\n",
       "      <td>龙王塘樱花园</td>\n",
       "      <td>10625</td>\n",
       "      <td>1.382312e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>61</td>\n",
       "      <td>大地艺术节+疯狂动物节+203樱花园 大套票</td>\n",
       "      <td>21.00</td>\n",
       "      <td>二0三樱花园</td>\n",
       "      <td>9801</td>\n",
       "      <td>2.058210e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>89</td>\n",
       "      <td>【服务费15元】</td>\n",
       "      <td>15.00</td>\n",
       "      <td>龙王塘樱花园</td>\n",
       "      <td>3000</td>\n",
       "      <td>4.500000e+04</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     0                            1      2       3          4             5\n",
       "0   50                  【二0三樱花园散客票】  27.00  龙王塘樱花园  119018916  3.213511e+09\n",
       "1   51               【龙王塘樱花园节假日团队票】  17.00    最新推荐    2016356  3.427805e+07\n",
       "2   53                【龙王塘樱花园平日团队票】  13.00  龙王塘樱花园    1435016  1.865521e+07\n",
       "3   62      【龙王塘樱花园散客平日电子票】需提前两小时订票  18.80  龙王塘樱花园     127098  2.389442e+06\n",
       "6   54          【龙王塘樱花园夜场票】需提前两小时订票   9.90  龙王塘樱花园      45435  4.498065e+05\n",
       "5   96  【龙王塘樱花园散客平日周末通用电子票】需提前两小时订票  18.88  龙王塘樱花园      40568  7.659238e+05\n",
       "4   98                  【二0三樱花园团队票】  21.00  龙王塘樱花园      40288  8.460480e+05\n",
       "8   91    平日 大地艺术节+疯狂动物节+龙王塘樱花园 大套票  13.01  龙王塘樱花园      10625  1.382312e+05\n",
       "7   61       大地艺术节+疯狂动物节+203樱花园 大套票  21.00  二0三樱花园       9801  2.058210e+05\n",
       "11  89                     【服务费15元】  15.00  龙王塘樱花园       3000  4.500000e+04"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Data.sort_values([4],ascending=False).head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>15</td>\n",
       "      <td>5.5寸安卓智能pda景区验券核销小票打印二维码扫描终端可二次开发</td>\n",
       "      <td>1299.0</td>\n",
       "      <td>最新推荐</td>\n",
       "      <td>4</td>\n",
       "      <td>5.196000e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>14</td>\n",
       "      <td>新疆 和田玉 手镯 羊脂玉手镯子女款 冰种天然白玉石手镯带证书</td>\n",
       "      <td>998.0</td>\n",
       "      <td>最新推荐</td>\n",
       "      <td>1</td>\n",
       "      <td>9.980000e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>32</td>\n",
       "      <td>海朴 淡干海参50g 大连刺参 底播干海参即食海参 臻鸾款</td>\n",
       "      <td>560.0</td>\n",
       "      <td>海参礼盒</td>\n",
       "      <td>1</td>\n",
       "      <td>5.600000e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>40</td>\n",
       "      <td>中远海运洲际酒店鲍鱼王子中餐厅-双人龙虾餐饭票</td>\n",
       "      <td>299.0</td>\n",
       "      <td>玩乐美食</td>\n",
       "      <td>3</td>\n",
       "      <td>8.970000e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>101</td>\n",
       "      <td>【二0三樱花园团体票】企事业单位团体票，10人一份</td>\n",
       "      <td>249.0</td>\n",
       "      <td>二0三樱花园</td>\n",
       "      <td>98</td>\n",
       "      <td>2.440200e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>49</td>\n",
       "      <td>龙王塘樱花园团队票</td>\n",
       "      <td>200.0</td>\n",
       "      <td>龙王塘樱花园</td>\n",
       "      <td>272</td>\n",
       "      <td>5.440000e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>13</td>\n",
       "      <td>凤华 双耳铸铁炒锅老式铁锅无涂层不生锈圆底加厚生铁炖锅炒菜锅</td>\n",
       "      <td>185.0</td>\n",
       "      <td>最新推荐</td>\n",
       "      <td>3</td>\n",
       "      <td>5.550000e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>63</td>\n",
       "      <td>话剧《开心晚宴》—大连站</td>\n",
       "      <td>180.0</td>\n",
       "      <td>文化大连</td>\n",
       "      <td>14</td>\n",
       "      <td>2.520000e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>27</td>\n",
       "      <td>海狸先生海鲜零食吃货大礼包1150g儿童零食组合装过年礼盒</td>\n",
       "      <td>159.0</td>\n",
       "      <td>海狸先生</td>\n",
       "      <td>1</td>\n",
       "      <td>1.590000e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>39</td>\n",
       "      <td>大连森林动物园 电子门票 成人票/半价票【当天可用 扫码入园】</td>\n",
       "      <td>98.0</td>\n",
       "      <td>玩乐美食</td>\n",
       "      <td>1</td>\n",
       "      <td>9.800000e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>1</td>\n",
       "      <td>青岛方特首届新春梦幻灯会来啦！夜场通玩票仅售89元！大年初一至十五，精彩上演不停歇！游方特，...</td>\n",
       "      <td>89.0</td>\n",
       "      <td>玩乐美食</td>\n",
       "      <td>4</td>\n",
       "      <td>3.560000e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>71</td>\n",
       "      <td>儿童剧《白雪公主》-大连站</td>\n",
       "      <td>80.0</td>\n",
       "      <td>文化大连</td>\n",
       "      <td>4</td>\n",
       "      <td>3.200000e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>66</td>\n",
       "      <td>《激情与技艺——十二星座三重奏音乐会》-大连站</td>\n",
       "      <td>60.0</td>\n",
       "      <td>文化大连</td>\n",
       "      <td>5</td>\n",
       "      <td>3.000000e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>65</td>\n",
       "      <td>《小象芭芭拉的故事——西班牙钢琴家巴勃罗•加尔多音乐故事会》-大连站</td>\n",
       "      <td>60.0</td>\n",
       "      <td>文化大连</td>\n",
       "      <td>6</td>\n",
       "      <td>3.600000e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>23</td>\n",
       "      <td>海狸先生海苔夹心脆40gX4罐海苔芝麻夹心脆夹心海苔即食儿童零食</td>\n",
       "      <td>53.6</td>\n",
       "      <td>海狸先生</td>\n",
       "      <td>1</td>\n",
       "      <td>5.360000e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>44</td>\n",
       "      <td>牛牛九九草莓采摘园</td>\n",
       "      <td>45.0</td>\n",
       "      <td>最新推荐</td>\n",
       "      <td>7</td>\n",
       "      <td>3.150000e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>92</td>\n",
       "      <td>龙王塘直通车—与樱共舞，来醉美大连，赏浪漫樱花。平日周末通用。需提前两小时订票</td>\n",
       "      <td>38.8</td>\n",
       "      <td>龙王塘樱花园</td>\n",
       "      <td>1704</td>\n",
       "      <td>6.611520e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>74</td>\n",
       "      <td>蓝莓饼，遇见莓好，吃到最美的那一颗</td>\n",
       "      <td>38.0</td>\n",
       "      <td>伴手大连</td>\n",
       "      <td>170</td>\n",
       "      <td>6.460000e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>56</td>\n",
       "      <td>槐花饼，又是一年槐花香，童年的味道</td>\n",
       "      <td>38.0</td>\n",
       "      <td>伴手大连</td>\n",
       "      <td>322</td>\n",
       "      <td>1.223600e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>72</td>\n",
       "      <td>樱花饼，樱花树下，白头偕老</td>\n",
       "      <td>38.0</td>\n",
       "      <td>伴手大连</td>\n",
       "      <td>300</td>\n",
       "      <td>1.140000e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>76</td>\n",
       "      <td>樱桃饼，青春和美好的无限挂念</td>\n",
       "      <td>38.0</td>\n",
       "      <td>伴手大连</td>\n",
       "      <td>315</td>\n",
       "      <td>1.197000e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>34</td>\n",
       "      <td>海狸先生 醋昆布5袋装醋海带条裙带菜即食海带零食海带丝开袋即食</td>\n",
       "      <td>34.9</td>\n",
       "      <td>鲜鲜零食</td>\n",
       "      <td>2</td>\n",
       "      <td>6.980000e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>11</td>\n",
       "      <td>【三只松鼠_纸皮核桃210gx2袋】坚果特产薄皮大仁带壳核桃干果</td>\n",
       "      <td>32.9</td>\n",
       "      <td>餐饮</td>\n",
       "      <td>4</td>\n",
       "      <td>1.316000e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>100</td>\n",
       "      <td>【二0三樱花园散客原价票】</td>\n",
       "      <td>30.0</td>\n",
       "      <td>二0三樱花园</td>\n",
       "      <td>250</td>\n",
       "      <td>7.500000e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>58</td>\n",
       "      <td>樱花贺卡，凝固时间，传情达义</td>\n",
       "      <td>29.9</td>\n",
       "      <td>周边小礼</td>\n",
       "      <td>336</td>\n",
       "      <td>1.004640e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>52</td>\n",
       "      <td>【佳和温泉水世界】3.8女王节特惠，仅售29.9元！大连奢华汤泉单人浴资门票火爆预售，汤泉沐...</td>\n",
       "      <td>29.9</td>\n",
       "      <td>玩乐美食</td>\n",
       "      <td>5</td>\n",
       "      <td>1.495000e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>50</td>\n",
       "      <td>【二0三樱花园散客票】</td>\n",
       "      <td>27.0</td>\n",
       "      <td>龙王塘樱花园</td>\n",
       "      <td>119018916</td>\n",
       "      <td>3.213511e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>28</td>\n",
       "      <td>海狸先生鳕鱼肠50g*5根儿童深海迷你小鱼肠雪鱼拇指肠鳕鱼棒</td>\n",
       "      <td>21.8</td>\n",
       "      <td>海狸先生</td>\n",
       "      <td>3</td>\n",
       "      <td>6.540000e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>61</td>\n",
       "      <td>大地艺术节+疯狂动物节+203樱花园 大套票</td>\n",
       "      <td>21.0</td>\n",
       "      <td>二0三樱花园</td>\n",
       "      <td>9801</td>\n",
       "      <td>2.058210e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>98</td>\n",
       "      <td>【二0三樱花园团队票】</td>\n",
       "      <td>21.0</td>\n",
       "      <td>龙王塘樱花园</td>\n",
       "      <td>40288</td>\n",
       "      <td>8.460480e+05</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      0                                                  1       2       3  \\\n",
       "22   15                  5.5寸安卓智能pda景区验券核销小票打印二维码扫描终端可二次开发  1299.0    最新推荐   \n",
       "25   14                    新疆 和田玉 手镯 羊脂玉手镯子女款 冰种天然白玉石手镯带证书   998.0    最新推荐   \n",
       "29   32                      海朴 淡干海参50g 大连刺参 底播干海参即食海参 臻鸾款   560.0    海参礼盒   \n",
       "26   40                            中远海运洲际酒店鲍鱼王子中餐厅-双人龙虾餐饭票   299.0    玩乐美食   \n",
       "12  101                          【二0三樱花园团体票】企事业单位团体票，10人一份   249.0  二0三樱花园   \n",
       "10   49                                          龙王塘樱花园团队票   200.0  龙王塘樱花园   \n",
       "30   13                     凤华 双耳铸铁炒锅老式铁锅无涂层不生锈圆底加厚生铁炖锅炒菜锅   185.0    最新推荐   \n",
       "23   63                                       话剧《开心晚宴》—大连站   180.0    文化大连   \n",
       "37   27                      海狸先生海鲜零食吃货大礼包1150g儿童零食组合装过年礼盒   159.0    海狸先生   \n",
       "40   39                    大连森林动物园 电子门票 成人票/半价票【当天可用 扫码入园】    98.0    玩乐美食   \n",
       "32    1  青岛方特首届新春梦幻灯会来啦！夜场通玩票仅售89元！大年初一至十五，精彩上演不停歇！游方特，...    89.0    玩乐美食   \n",
       "33   71                                      儿童剧《白雪公主》-大连站    80.0    文化大连   \n",
       "35   66                            《激情与技艺——十二星座三重奏音乐会》-大连站    60.0    文化大连   \n",
       "31   65                 《小象芭芭拉的故事——西班牙钢琴家巴勃罗•加尔多音乐故事会》-大连站    60.0    文化大连   \n",
       "45   23                   海狸先生海苔夹心脆40gX4罐海苔芝麻夹心脆夹心海苔即食儿童零食    53.6    海狸先生   \n",
       "34   44                                          牛牛九九草莓采摘园    45.0    最新推荐   \n",
       "9    92            龙王塘直通车—与樱共舞，来醉美大连，赏浪漫樱花。平日周末通用。需提前两小时订票    38.8  龙王塘樱花园   \n",
       "21   74                                  蓝莓饼，遇见莓好，吃到最美的那一颗    38.0    伴手大连   \n",
       "14   56                                  槐花饼，又是一年槐花香，童年的味道    38.0    伴手大连   \n",
       "16   72                                      樱花饼，樱花树下，白头偕老    38.0    伴手大连   \n",
       "15   76                                     樱桃饼，青春和美好的无限挂念    38.0    伴手大连   \n",
       "42   34                    海狸先生 醋昆布5袋装醋海带条裙带菜即食海带零食海带丝开袋即食    34.9    鲜鲜零食   \n",
       "39   11                   【三只松鼠_纸皮核桃210gx2袋】坚果特产薄皮大仁带壳核桃干果    32.9      餐饮   \n",
       "19  100                                      【二0三樱花园散客原价票】    30.0  二0三樱花园   \n",
       "17   58                                     樱花贺卡，凝固时间，传情达义    29.9    周边小礼   \n",
       "38   52  【佳和温泉水世界】3.8女王节特惠，仅售29.9元！大连奢华汤泉单人浴资门票火爆预售，汤泉沐...    29.9    玩乐美食   \n",
       "0    50                                        【二0三樱花园散客票】    27.0  龙王塘樱花园   \n",
       "43   28                     海狸先生鳕鱼肠50g*5根儿童深海迷你小鱼肠雪鱼拇指肠鳕鱼棒    21.8    海狸先生   \n",
       "7    61                             大地艺术节+疯狂动物节+203樱花园 大套票    21.0  二0三樱花园   \n",
       "4    98                                        【二0三樱花园团队票】    21.0  龙王塘樱花园   \n",
       "\n",
       "            4             5  \n",
       "22          4  5.196000e+03  \n",
       "25          1  9.980000e+02  \n",
       "29          1  5.600000e+02  \n",
       "26          3  8.970000e+02  \n",
       "12         98  2.440200e+04  \n",
       "10        272  5.440000e+04  \n",
       "30          3  5.550000e+02  \n",
       "23         14  2.520000e+03  \n",
       "37          1  1.590000e+02  \n",
       "40          1  9.800000e+01  \n",
       "32          4  3.560000e+02  \n",
       "33          4  3.200000e+02  \n",
       "35          5  3.000000e+02  \n",
       "31          6  3.600000e+02  \n",
       "45          1  5.360000e+01  \n",
       "34          7  3.150000e+02  \n",
       "9        1704  6.611520e+04  \n",
       "21        170  6.460000e+03  \n",
       "14        322  1.223600e+04  \n",
       "16        300  1.140000e+04  \n",
       "15        315  1.197000e+04  \n",
       "42          2  6.980000e+01  \n",
       "39          4  1.316000e+02  \n",
       "19        250  7.500000e+03  \n",
       "17        336  1.004640e+04  \n",
       "38          5  1.495000e+02  \n",
       "0   119018916  3.213511e+09  \n",
       "43          3  6.540000e+01  \n",
       "7        9801  2.058210e+05  \n",
       "4       40288  8.460480e+05  "
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Data.sort_values([2],ascending=False).head(30)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>sum</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>龙王塘樱花园</th>\n",
       "      <td>120725707</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>最新推荐</th>\n",
       "      <td>2016395</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>二0三樱花园</th>\n",
       "      <td>10149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>伴手大连</th>\n",
       "      <td>1173</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>周边小礼</th>\n",
       "      <td>786</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>文化大连</th>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>玩乐美食</th>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>食品</th>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>鲜鲜零食</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>海狸先生</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>餐饮</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>海参礼盒</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              sum\n",
       "3                \n",
       "龙王塘樱花园  120725707\n",
       "最新推荐      2016395\n",
       "二0三樱花园      10149\n",
       "伴手大连         1173\n",
       "周边小礼          786\n",
       "文化大连           29\n",
       "玩乐美食           13\n",
       "食品              8\n",
       "鲜鲜零食            6\n",
       "海狸先生            5\n",
       "餐饮              4\n",
       "海参礼盒            1"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Data.groupby(3)[4].agg([\"sum\"]).sort_values(\"sum\",ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0xae02fd0>"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "D:\\Program Files (x86)\\Microsoft Visual Studio\\Shared\\Anaconda3_64\\lib\\site-packages\\matplotlib\\font_manager.py:1328: UserWarning: findfont: Font family ['SeiHei'] not found. Falling back to DejaVu Sans\n",
      "  (prop.get_family(), self.defaultFamily[fontext]))\n"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXcAAAEsCAYAAAA4ifPKAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMi4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvhp/UCwAAEt1JREFUeJzt3X+s3XV9x/Hnu+2FEvlhbO8y4LZespWMjopsN+DmH8JkpIWE+oc6mrGxpdosG25Gw6/MIMPEMJfNbAnius1UTWZFRemkglMxsimO2yg/SseswOSmi5T6K6IdLbz3xzmw4+Xee86999tz7nn7fCQ3nO/3++l5v7/fktf99vv9nO+JzESSVMuyQTcgSWqe4S5JBRnuklSQ4S5JBRnuklSQ4S5JBQ003CPiQxHxVEQ83MPYtRFxT0R8IyIejIhL+tGjJA2jQZ+57wA29jj2XcBtmXkucDnwgWPVlCQNu4GGe2Z+Bfhe57qI+KWIuCsi9kTEvRHxKy8MB05uvz4FONDHViVpqKwYdAMz2A78UWZ+KyLOp3WG/lvAjcDnI+JtwMuAiwbXoiQtbUsq3CPiROA3gU9ExAurj2//dwuwIzP/OiJ+A/hoRJydmc8PoFVJWtKWVLjTukz0g8x89QzbttK+Pp+ZX4uIlcBq4Kk+9idJQ2HQN1R/Rmb+CHg8It4EEC3ntDd/B3h9e/1ZwErg4EAalaQlLgb5VMiI+BhwAa0z8O8C7wa+BNwKnAqMADsz86aIWA/8A3AirZur12Tm5wfRtyQtdQMNd0nSsbGkLstIkpphuEtSQQObLbN69eocHx8fVHlJGkp79ux5OjNHu40bWLiPj48zOTk5qPKSNJQi4r97GedlGUkqyHCXpIIMd0kqaKk9fkCSenLkyBGmpqY4fPjwoFs5JlauXMnY2BgjIyML+vOGu6ShNDU1xUknncT4+DgdDxosITM5dOgQU1NTnHHGGQt6Dy/LSBpKhw8fZtWqVeWCHSAiWLVq1aL+VdI13Lt9FV5E/G77a+8ejIivdjzoS5KOqYrB/oLF7lsvZ+47mPur8B4HXpeZrwLeQ+vLNiRJA9T1mntmfiUixufY/tWOxfuAscU2NX7dnQv6c0/cfOliS0saUgvNjdkMe540fc19K/C5ht9TkpacZ555hksvvZRzzjmHs88+m49//OOMj4/z9NNPAzA5OckFF1wAwI033siVV17JxRdfzPj4OLfffjvXXHMNGzZsYOPGjRw5cqTx/hoL94i4kFa4XzvHmG0RMRkRkwcP+j0bkobXXXfdxWmnncYDDzzAww8/zMaNc129hm9/+9vceeed3HHHHVxxxRVceOGFPPTQQ5xwwgnceWez/+qAhsI9Il4F/COwOTMPzTYuM7dn5kRmToyOdn3ujSQtWRs2bOALX/gC1157Lffeey+nnHLKnOM3bdrEyMgIGzZs4Lnnnnvxl8GGDRt44oknGu9v0fPcI2ItcDvwe5n5X4tvSZKWvjPPPJM9e/awe/durr/+ei6++GJWrFjB888/D/CSaYzHH388AMuWLWNkZOTF2TDLli3j6NGjjffXNdw7vwovIqZofRXeCEBmfhC4AVgFfKDd7NHMnGi8U0laQg4cOMArXvEKrrjiCk488UR27NjB+Pg4e/bsYdOmTXzqU58aaH+9zJbZ0mX7W4C3NNaRJA2Bhx56iKuvvvrFM/Fbb72Vn/70p2zdupX3vve9nH/++QPtb2DfoToxMZGzPc/dqZCSutm3bx9nnXXWoNs4pmbax4jY08vVER8/IEkFGe6SVJDhLkkFGe6Shtag7hn2w2L3zXCXNJRWrlzJoUOHSgb8C89zX7ly5YLfwy/rkDSUxsbGmJqaouqjTF74JqaFMtwlDaWRkZEFf0vRzwMvy0hSQYa7JBVkuEtSQYa7JBVkuEtSQYa7JBVkuEtSQYa7JBVkuEtSQYa7JBVkuEtSQYa7JBVkuEtSQYa7JBVkuEtSQYa7JBVkuEtSQV3DPSI+FBFPRcTDs2yPiPi7iNgfEQ9GxK8136YkaT56OXPfAWycY/smYF37Zxtw6+LbkiQtRtdwz8yvAN+bY8hm4CPZch/w8og4takGJUnz18Q199OBJzuWp9rrJEkD0kS4xwzrcsaBEdsiYjIiJg8ePNhAaUnSTJoI9ylgTcfyGHBgpoGZuT0zJzJzYnR0tIHSkqSZNBHuu4Dfb8+aeQ3ww8z8nwbeV5K0QCu6DYiIjwEXAKsjYgp4NzACkJkfBHYDlwD7gZ8Af3ismpUk9aZruGfmli7bE/iTxjqSJC2an1CVpIIMd0kqyHCXpIIMd0kqyHCXpIIMd0kqyHCXpIIMd0kqyHCXpIIMd0kqyHCXpIIMd0kqyHCXpIIMd0kqyHCXpIIMd0kqyHCXpIIMd0kqyHCXpIIMd0kqyHCXpIIMd0kqyHCXpIIMd0kqyHCXpIJ6CveI2BgRj0bE/oi4bobtayPinoj4RkQ8GBGXNN+qJKlXXcM9IpYDtwCbgPXAlohYP23Yu4DbMvNc4HLgA003KknqXS9n7ucB+zPzscx8FtgJbJ42JoGT269PAQ4016Ikab5W9DDmdODJjuUp4PxpY24EPh8RbwNeBlzUSHeSpAXp5cw9ZliX05a3ADsycwy4BPhoRLzkvSNiW0RMRsTkwYMH59+tJKknvYT7FLCmY3mMl1522QrcBpCZXwNWAqunv1Fmbs/MicycGB0dXVjHkqSuegn3+4F1EXFGRBxH64bprmljvgO8HiAizqIV7p6aS9KAdA33zDwKXAXcDeyjNStmb0TcFBGXtYe9E3hrRDwAfAz4g8ycfulGktQnvdxQJTN3A7unrbuh4/UjwGubbU2StFB+QlWSCjLcJakgw12SCjLcJakgw12SCjLcJakgw12SCjLcJakgw12SCjLcJakgw12SCjLcJakgw12SCjLcJakgw12SCjLcJakgw12SCjLcJakgw12SCjLcJakgw12SCjLcJakgw12SCjLcJakgw12SCjLcJamgnsI9IjZGxKMRsT8irptlzJsj4pGI2BsR/9xsm5Kk+VjRbUBELAduAX4bmALuj4hdmflIx5h1wPXAazPz+xHxC8eqYUlSd72cuZ8H7M/MxzLzWWAnsHnamLcCt2Tm9wEy86lm25QkzUcv4X468GTH8lR7XaczgTMj4t8j4r6I2NhUg5Kk+et6WQaIGdblDO+zDrgAGAPujYizM/MHP/NGEduAbQBr166dd7OSpN70cuY+BazpWB4DDsww5o7MPJKZjwOP0gr7n5GZ2zNzIjMnRkdHF9qzJKmLXsL9fmBdRJwREccBlwO7po35DHAhQESspnWZ5rEmG5Uk9a5ruGfmUeAq4G5gH3BbZu6NiJsi4rL2sLuBQxHxCHAPcHVmHjpWTUuS5tbLNXcyczewe9q6GzpeJ/CO9o8kacD8hKokFWS4S1JBhrskFWS4S1JBhrskFWS4S1JBhrskFWS4S1JBhrskFWS4S1JBhrskFWS4S1JBhrskFWS4S1JBhrskFWS4S1JBhrskFWS4S1JBhrskFWS4S1JBhrskFWS4S1JBhrskFWS4S1JBhrskFdRTuEfExoh4NCL2R8R1c4x7Y0RkREw016Ikab66hntELAduATYB64EtEbF+hnEnAX8KfL3pJiVJ89PLmft5wP7MfCwznwV2AptnGPce4H3A4Qb7kyQtQC/hfjrwZMfyVHvdiyLiXGBNZn62wd4kSQvUS7jHDOvyxY0Ry4D3A+/s+kYR2yJiMiImDx482HuXkqR56SXcp4A1HctjwIGO5ZOAs4EvR8QTwGuAXTPdVM3M7Zk5kZkTo6OjC+9akjSnXsL9fmBdRJwREccBlwO7XtiYmT/MzNWZOZ6Z48B9wGWZOXlMOpYkddU13DPzKHAVcDewD7gtM/dGxE0RcdmxblCSNH8rehmUmbuB3dPW3TDL2AsW35YkaTH8hKokFWS4S1JBhrskFWS4S1JBhrskFWS4S1JBhrskFWS4S1JBhrskFWS4S1JBhrskFWS4S1JBhrskFWS4S1JBhrskFWS4S1JBhrskFWS4S1JBhrskFWS4S1JBhrskFWS4S1JBhrskFWS4S1JBhrskFdRTuEfExoh4NCL2R8R1M2x/R0Q8EhEPRsQXI+KVzbcqSepV13CPiOXALcAmYD2wJSLWTxv2DWAiM18FfBJ4X9ONSpJ618uZ+3nA/sx8LDOfBXYCmzsHZOY9mfmT9uJ9wFizbUqS5qOXcD8deLJjeaq9bjZbgc8tpilJ0uKs6GFMzLAuZxwYcQUwAbxulu3bgG0Aa9eu7bFFSdJ89XLmPgWs6VgeAw5MHxQRFwF/DlyWmf870xtl5vbMnMjMidHR0YX0K0nqQS/hfj+wLiLOiIjjgMuBXZ0DIuJc4O9pBftTzbcpSZqPruGemUeBq4C7gX3AbZm5NyJuiojL2sP+CjgR+EREfDMids3ydpKkPujlmjuZuRvYPW3dDR2vL2q4L0nSIvgJVUkqyHCXpIIMd0kqyHCXpIIMd0kqyHCXpIIMd0kqyHCXpIIMd0kqyHCXpIIMd0kqyHCXpIIMd0kqyHCXpIIMd0kqyHCXpIIMd0kqyHCXpIIMd0kqyHCXpIIMd0kqyHCXpIIMd0kqyHCXpIIMd0kqyHCXpIJW9DIoIjYCfwssB/4xM2+etv144CPArwOHgN/JzCeabfXYGb/uzgX9uSduvrThTiSpGV3P3CNiOXALsAlYD2yJiPXThm0Fvp+Zvwy8H/jLphuVJPWul8sy5wH7M/OxzHwW2AlsnjZmM/Dh9utPAq+PiGiuTUnSfPQS7qcDT3YsT7XXzTgmM48CPwRWNdGgJGn+ernmPtMZeC5gDBGxDdjWXvxxRDzaQ/3pVgNPz7Qhjs3FoCVT7xix3vDWq7xv1pvdK3sZ1Eu4TwFrOpbHgAOzjJmKiBXAKcD3pr9RZm4HtvfS2GwiYjIzJxbzHtazXoV6lffNeovXy2WZ+4F1EXFGRBwHXA7smjZmF3Bl+/UbgS9l5kvO3CVJ/dH1zD0zj0bEVcDdtKZCfigz90bETcBkZu4C/gn4aETsp3XGfvmxbFqSNLee5rln5m5g97R1N3S8Pgy8qdnWZrWoyzrWs16hepX3zXqLFF49kaR6fPyAJBVkuEtSQYa7JBXU0w3VQYqIG7oMeSozPzjE9T4NPD7bZuD4zPzjButVP57Ws96SqzWIemTmkv6hNUvnZFofjJrp5zNDXu9fumz/9JDvn/WstyTrVd63zFz6Z+7Ac5n5o9k2RkTT0336Xa/b+w37/lnPeku1XuV9G4pr7v0Ov37X67fqx9N61luKtfpebxjO3Eci4uRZtgWtT80Oc71fjIjL5qh3YsP1qh9P61lvKdbqe71hCPf7gLfPsf1zQ17vaub+jX19w/WqH8+f53rR53oMeb3Sx3IYwh1mfqRwlXpvpzVbZraaxwN7Gq5Z+XhWr3c+rWc3zVbzw0BzMy5aqh7P0sdyGMK9338B/a63IjPfMdvG9lTJJlU/ntXr9fsmYOXjWfpYDkO4l76jjbNlrDc//v/SnNLHchjCvfQd7QGofjyr1+v3TcDKx7P0sRyGcC99Rxtny1hvfl64KTfbP+3varhe5eNZ+lgu+Uf+RsS7mfs3WtMfEe53vdd1qfdMZjZ2Q/Xn4HiWrtdvHs/m9HvfhuHMHererQdny1hv6fN4NsfZMh0q360HZ8tYb2nzeDbH2TLTVL5bD8Xv2Fuv8Xr95vFsjs+Wmaby3fpBqH48q9frN49nc5wtM03lu/XgbBnrLW0ez+b4bJlpltKzLY7F8yaW0rNl+v08DestfR7P5vR134Yh3KH2szv6PVum+g2y6vX6zePZHG+oTlP92R39ni1T/QZZ9Xr95vFsjo8fmKb67BXrWW8p83g2xxuq01R/dke/Vb9BVr1ev3k8m+MN1WmqP7uj37Nl+r1/1htuHs/m9HXffLbMgM3ybJnOv/xnMnOyjy1JKmAYztyh9rMmvgu8ATiNVsgfAHZl5r6BdiVpqA3DmftuusyWycw39LGlxkTEtcAWYCcw1V49Rmt/d2bmzYPqTdJwG4Yz98pTo7YCv5qZRzpXRsTfAHsBw13SgvhsmcF6ntblmOlObW+TpAUZhjP3ylOj3g58MSK+BTzZXrcGWAdcNbCuJA29YbjmPtdsmQC+O+SzZW4CzgNOp7U/U8D9wFFa+z3Us4EkDcYwnLlXftYEwATwZurun6QBGIZwr3xDFervn6QB8Ibq4FXfP0kDMAxn7pVvqEL9/ZM0AMMQ7pWfNQH190/SACz52TKSpPkbhmvukqR5MtwlqSDDXWqLiJUR8R8R8UBE7I2Ivxh0T9JCec1daouIAF6WmT+OiBHg34A/y8z7BtyaNG/DMFtG6otsnen8uL040v7x7EdDycsyUoeIWB4R3wSeAv41M78+6J6khTDcpQ6Z+VxmvprWl6acFxFnD7onaSEMd2kGmfkD4MvAxgG3Ii2I4S61RcRoRLy8/foE4CLgPwfblbQw3lCV/t+pwIcjYjmtE5/bMvOzA+5JWhCnQkpSQV6WkaSCDHdJKshwl6SCDHdJKshwl6SCDHdJKshwl6SCDHdJKuj/AFhQ1f34NEK7AAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "Data.groupby(3)[4].agg([\"sum\"]).sort_values(\"sum\",ascending=False).plot(kind=\"bar\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
